<html xmlns="http://www.w3.org/1999/xhtml">

  <head>
    <title>Untitled Page</title>
  </head>
  <script language="javascript" type="text/javascript">
    function importXLS(fileName) {
      objCon = new ActiveXObject("ADODB.Connection");
      objCon.Provider = "Microsoft.Jet.OLEDB.4.0";
      objCon.ConnectionString = "Data Source=" + fileName + ";Extended Properties=Excel 8.0;";
      objCon.CursorLocation = 1;
      objCon.Open;
      var strQuery;
      //Get the SheetName
      var strSheetName = "Sheet1$";
      var rsTemp = new ActiveXObject("ADODB.Recordset");
      rsTemp = objCon.OpenSchema(20);
      if(!rsTemp.EOF)
        strSheetName = rsTemp.Fields("Table_Name").Value;
      rsTemp = null;
      rsExcel = new ActiveXObject("ADODB.Recordset");
      strQuery = "SELECT * FROM [" + strSheetName + "]";
      rsExcel.ActiveConnection = objCon;
      rsExcel.Open(strQuery);
      while(!rsExcel.EOF) {
        for(i = 0; i < rsExcel.Fields.Count; ++i) {
          alert(rsExcel.Fields(i).value);
        }
        rsExcel.MoveNext;
      }
      // Close the connection and dispose the file
      objCon.Close;
      objCon = null;
      rsExcel = null;
    }
  </script>
  </head>

  <body>
    <div style="width: 200px;height: 200px;border: 1px solid red;" style="border: 1px solid #000;"></div>
    <input type="file" id="f" />
    <input type="button" id="b" value="import" onclick="if(f.value=='')alert('请选择xls文件');else importXLS(f.value)" />
  </body>

</html>